FILE NAME: SIM76_hotfix_2023_Apr_linux.tar.gz TITLE: Hotfix Update Kit for HPE Systems Insight Manager 7.6 - Linux (April 2023) LANGUAGE: English OPERATING SYSTEM: All supported Linux operating systems. PREREQUISITES: HPE Systems Insight Manager 7.6 - Linux EFFECTIVE DATE: April 27 2023 DESCRIPTION: Hotfix Update Kit for HPE Systems Insight Manager 7.6 - Linux (April 2023) This is a cumulative Hotfix Update Kit and installs hotfixes to HPE Systems Insight Manager 7.6 HPE SIM enhancements and defect fixes in April 2023 hotfix update kit: New hardware and software support: New OS Support: - Red Hat Enterprise Linux 8.7 managed node support - Added support for Gen10 SPP 2023.03.0.0 - Added support for iLO5 v2.81 - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.85) - Integrated SPP Gen10 2023.03.0.0 components - Integrated SUM 10.2.0 - Integrated Openssl-1.1.1t for Windows and Linux - Integrated VCRM v7.6.17.0 Windows package - Integrated VCRM v7.6.13.0 Linux package - Updated Maverick Library - Updated the commons-fileupload version from 1.3.3 to 1.5v for security issue. Provides fix for following issue: - Licensing function not working, "shows no license available". - Event functionality not working in in HPUX CMS wit pass 103. - SNMP configuration failure on rhel 8x - removed statements printing password as plain text. HPE SIM enhancements and defect fixes in October 2022 hotfix update kit: New hardware and software support: New OS Support: - Red Hat Enterprise Linux 8.6 managed node support - SUSE LINUX Enterprise Server 15 SP4 managed node support - HP-UX 2205 managed node support - Added support for Gen10 SPP 2022.09.0 - Added support for iLO5 v2.72 - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.80) - Integrated OpenJDK 1.8.0_332 for windows - Integrated OpenJDK 1.8.0_345 for Linux - Integrated JDK 1.8.0_24 for HP-UX - Integrated SPP Gen10 2022.09.0.0 components - Integrated SUM 9.1.0 - Integrated Openssl-1.1.1q for Windows and Linux - Integrated Openssl-1.1.1p for HP-UX - Integrated VCRM v7.6.15.0 Windows package - Integrated VCRM v7.6.12.0 Linux package - Updated Maverick license HPE SIM enhancements and defect fixes in April 2022 hotfix update kit: -New OS Support: - Red Hat Enterprise Linux 8.5 managed node support - Added support for Gen10 SPP 2022.03.0 - Added support for Gen9.0 SPP 2022.03.0 - Added support for iLO5 v2.65 and iLO4 v2.80 - Integrated Gen9.0/Gen10 SPP 2022.03.0 components - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.75) - Integrated SUM 8.9.5 - Integrated VCRM v7.6.13 Windows package - Integrated VCRM v7.6.11 Linux package - Integrated Openssl-1.1.1n for Windows and Linux - Integrated the OpenSSH v8.9p1-1 into SIM code base - Updated Maverick License Provides fix for following issue: - Updated pg_hba.config file from trust to "md5" value HPE SIM enhancements and defect fixes in November 2021 hotfix update kit: New hardware and software support: - New OS Support: - SUSE LINUX Enterprise Server 15 SP3 managed node support - Red Hat Enterprise Linux 8.4 managed node support - Support for VMware ESXi 7.0 Update3 - Added support for Gen10 SPP 2021.10.0 - Added support for Gen9 SPP 2021.10.0 - Added support for iLO5 v2.55 and iLO4 v2.78 - Added support for HPE Intelligent Provisioning 3.70 - Integrated Gen9/Gen10 SPP 2021.10.0 components - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.70) - Integrated SUM 8.9.0 - Integrated VCRM v7.6.12 Windows package - Integrated VCRM v7.6.10 Linux package - Integrated OJDKBuild (OpenJDK) 1.8.0_302 Provides fixes for following issues: - First Time Wizard fails to create tasks with Aug 2021 HF - User created discovery tasks are not listed with Aug 2021 HF - Fixed OpenSSH upgrade failures - Prevent Software Version Numbers in HTTP Response headers - Add charset in Content-Type of HTTP Response headers HPE SIM enhancements and defect fixes in August 2021 hotfix update kit: New hardware and software support: - Removed support for hpsmdb Database - Added Data migration support for hpsmdb to PostgreSQL (Refer to "2. HOW TO INSTALL POSTGRESQL ON LINUX" section for more details) Known Issues: 1. HPE SIM 7.6 install on latest operating systems of SLES12 SPx (Ex: SLES12 SP5) may show an error "You appear to be running an unsupported operating system" Suggested Action: Refer "Manually installing HPE SIM" section from "HPE Systems Insight Manager 7.6 Installation and Configuration Guide for Linux" to install HPE SIM 7.6 followed by the Hotfix install procedure explained in section 1 below. 2. Linux VCRM service fails to start on SLES12SP5 Suggested Action: use remote Windows Version Control Repository Manger (VCRM). HPE SIM enhancements and defect fixes in Apr2021 hotfix update kit: New hardware and software support: - Added support for latest Gen10Plus Hardware: - HPE ProLiant DL325 Gen10 plus Server - HPE ProLiant DL345 Gen10 Plus Server - HPE ProLiant DL365 Gen10 Plus Server - HPE ProLiant DL385 Gen10 Plus Server - HPE Apollo 6500 Gen10 Plus System - New OS Support: - Red Hat Enterprise Linux 7.9 managed node support - Red Hat Enterprise Linux 8.3 managed node support - HPUX 2105 managed node support - Support for VMware ESXi 7.0 Update2 - Added support for Gen10Plus SPP 2021.05.0 - Added support for iLO5 v2.42 and iLO4 v2.77 - Added support for OA v4.97 - Added support for HPE Intelligent Provisioning 3.60 - Added support for 3PAR 3.3.2 - Integrated SPP Gen10Plus SPP 2021.05.0 components - Integrated SNMP-MIBs for Gen10 Plus hardware (MIB Kit v11.60) - Integrated SUM 8.8.0 - Integrated VCRM v7.6.10 Windows package - Integrated VCRM v7.6.9 Linux package - Updated Maverick license - Removal of Adobe flash player plugin in SIM - Rebranding changes(HP to HPE) in Configure or Repair Agents Page - Integrated the OpenSSH v8.4p1-1 into SIM code base - Upgraded OpenSSL to version openssl-1.1.1h for Windows - [Windows x86 build is done using VS 2012] - Upgraded OpenSSL to openssl-1.1.1h version for Linux Provides fixes for following issues: - Includes Fix for CVE-2020-7200 - Removed the faulty dmtfdmi.mib from MIBKIT 11.60 - WBEM discovery is failing from HPE SIM 7.6 (Apr-2021) Hotfix Pass 72 - SW status listing wrong info for AMS and kernel modules in RHEL 7.9 and RHEL 8.3 - [Track hp-snmp-agents]Linux agents deployments failing through CRA - Enhanced reports, federated search & federated CMS config launches using flash player - CLI commands failing from Linux CMS(HPE SIM 7.6 (Apr-2021) Hotfix - mxversion cmd do not work in OCT2020 hotfix for linux HPE SIM enhancements and defect fixes in OCT2020 hotfix update kit: New hardware and software support: - New OS Support: Red Hat Enterprise Linux 8.2 managed node support Red Hat Enterprise Linux 7.8 managed node support SUSE LINUX Enterprise Server 15 SP2 managed node support HPUX 2005 managed node support Support for VMware vSphere 7.0 and VMware vSphere 7.0 Update1 - Added support for Gen10Plus SPP 2020.09.0 - Added support for iLO5 v2.30, iLO4 v2.74 and iLO3 v1.93 - Added support for OA v4.96 - Added support for Virtual Connect v4.85 - Added support for HPE Intelligent Provisioning 3.50 - Added support for 3PAR 3.3.1 MU5 - Integrated SPP Gen10Plus SPP 2020.09.0 components - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.50) - Integrated OpenSSH v8.3p1-1 into SIM code base. - Integrated HPSUM 8.7.0 - Integrated VCRM v7.6.9.0 Windows package - Integrated VCRM v7.6.8.0 Linux package - Integrated Adobe flash player 32.0.387 - Integrated OpenSSL 1.1.1 Provides fixes for following issues: - Removed vulnerable servlet to fix CVE-2017-7504. - After deleting and re-adding cpqida.mib the subcategory values are updated to noticeType table. - Deployments on Linux targets from Windows, Linux CMS(with SUM8.7b40) failed. - Email Report task fails for the SIM Power related enhanced report - CLI commands failing from HPUX CMS - Software status listing wrong information for SLES12SP5 and RHEL8.1 targets - Deployments on ESXI7.0U1 target failed from Windows CMS HPE SIM enhancements and defect fixes in Feb2020 hotfix update kit: New hardware and software support: - Added support for latest Gen10Plus Hardware [For Details, refer to latest Insight Management 7.6 LR5 Support Matrix Guide] - Added support for Gen10Plus SPP 2019.12.0 - Added support for iLO5 v2.10 - Added support for OA v4.95 - Added support for Virtual Connect v4.80 - Added support for HPE Intelligent Provisioning 3.40 - Added support for Microsoft SQL Server 2019 Database - Integrated SUM 8.5.0(A) - Integrated VCRM 7.6.8 Windows package - Integrated VCRM 7.6.7 Linux package - Integrated WMIMapper 7.6.1 Windows package - Integrated Gen10Plus SPP 2019.12.0 components - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.40) Provides fixes for following issues: - Environment variables for custom tools fails for specific user - CRA on SLES15 Sp1 fails as it can not find the right path for the component - CRA on RHEL8 to install AMS skips - Software status listing wrong information for SLES15 SP1 target - Deployments given through Custom Baseline on Linux targets failing - Wbem health inclusion is not working on ESXI 6.7/6.7 U1/6.7U2(Gen9,Gen10targets) - AMS installation through CRA on multiple targets(Gen9 and Gen10) failed - [SV] OpenSSH 7.9 vulnerable to track the SV - Text file missing in the HPSUM folder - [SV] AppScan has flagged the use of Unsafe third-party link (target="_blank") HPE SIM enhancements and defect fixes in Oct2019 hotfix update kit: New hardware and software support: - New OS Support: Red Hat Enterprise Linux 7.7 managed node support Red Hat Enterprise Linux 8.0 managed node support SUSE LINUX Enterprise Server 15 SP1 managed node support ESXi versions 6.5U3, 6.7U2 and 6.7U3 managed node support - Added support for Gen10 SPP 2019.09.0 - Added support for iLO5 v1.45 - Added support for iLO4 v2.70 - Added support for Virtual Connect v4.75 - Integrated VCRM 7.6.7 Windows package - Integrated VCRM 7.6.6 Linux package - Integrated SMH 7.6.5 Linux package - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.35) - Integrated SUM 8.4.5 - Integrated Gen10 SPP 2019.09.0 components Provides fixes for following issues: - Environment variables for custom tools fails for specific user - Deployments given through Custom Baseline on Linux targets failing - Wbem health inclusion is not working on ESXI 6.7/6.7 U1/6.7U2(Gen9 targets) HPE SIM enhancements and defect fixes in Apr2019 hotfix update kit: New hardware and software support: - Added support for latest Gen10 Hardware [For Details, refer to latest Insight Management 7.6 LR4 Support Matrix Guide] - Added support for new OS [Managed node, Software [refer to latest Insight Management 7.6 LR4 Support Matrix Guide] - Added support for Microsoft SQL Server 2014 Service Pack 3 database - Added support for Gen10 SPP 2019.03.0 - Added support for iLO5 v1.40 - Added support for Adobe flash player 32 - Added support for OA 4.90 - Added support for NCDE 12.40 - Added support for HPE Intelligent Provisioning 3.30 - Added support for Virtual Connect v4.63 - New OS Support: Red Hat Enterprise Linux 7.6 Server managed node SUSE LINUX Enterprise Server 12 SP4 managed node ESXi 6.7 and ESXi 6.7U1 support HPUX 1905 CMS and managed node - Integrated SUM 8.4.0 - Integrated SPP Gen10 Snap4 2019.03.0 components - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.30) - Integrated VCRM 7.6.6 Windows package - Integrated VCRM 7.6.5 Linux package Provides fixes for following issues: - Add support to launch iLO Remote Console via HPSIM SSO using Java Web Start - AMS installation failing through CRA on linux target - OpenSSH failed through Deploy->Deploy Driver,Firmware and Agents->InstallOpenSSH - SNMP Discovery of Windows 2016 RS4 showing wrong OS name - CRA task result incomplete message on Gen9 manage node with windows server 2019 - Offline deployment failing on Gen10 target - AMS installation through CRA failing on windows 2019 target - Servers not listing in servers tab of HPMIO page - SIM should return an error if the ILO license is not applied on ILO5/ILO4/ILO3 - AMSD not selected in Gen10snap3 SPP force install on Linux OS - Sign-in credentials are not saved in system page when ILO is discovered - HPNLP event shown as generic instead of Enterprise specific - ESXi 6.7U1/6.7 hosts-guest associations breaks when the hosts are re-discovered HPE SIM enhancements and defect fixes in Dec2018 hotfix update kit: New hardware and software support: - Added support for new OS [Managed node, Software [for details, refer to HPE SIM 7.6 LR3 Release notes] - Added support for Gen10 SPP 2018.09.0 and SPP 2018.11.0 - Added support for iLO5 v1.37 - Added support for Adobe flash player 31 - Added support for 3PAR 3.3.1 MU3 OS [for details, refer to HPE SIM 7.6 LR3 Release notes] - Added support for 3PAR 3.3.1 T05 OS [for details, refer to HPE SIM 7.6 LR3 Release notes] - New OS support : SUSE LINUX Enterprise Server 15.0 managed node Red Hat Enterprise Linux 6.10 Server (x86-64) managed node Microsoft Windows Server 2019 managed node - Integrated SNMP-MIBs for Gen-10 hardware (MIB Kit v11.25) - Integrated VCRM 7.6.5 Windows package - Integrated VCRM 7.6.4 Linux package - Integrated Gen-10 SPP 2018.11.0 components - Integrated SUM 8.3.7 Provides fixes for following issues: - Discovery filter settings, All checkboxes disabled - Configure or Repair Agent wizard does not save IRS data - HPSIM mxnodesecurity valid characters and delimiters - SIM needs to bundle Adobe Flash Player 30 - HP AMS and Linux agents installation is failing on SLES 15 through CRA - HPSIM linux remove or alter changes to startup runlevels - Upgraded Open SSH to 7.8 for CVE-2018-15473 - Open SSH is not getting installed on windows 2019 target through HPSIM - HPSIM needs to move to systemd and systemctl - OS type showing wrong while discover through AMS for SLES15 server - AMS installation is failing through CRA on Gen9 managed node with windows2019 OS HPE SIM enhancements and defect fixes in June2018 hotfix update kit: New hardware and software support: - Added support for latest Gen10 Hardware [For Details, refer to latest Insight Management 7.6 LR2 Support Matrix Guide] - Added support for new OS [Managed node], Software [For Details, refer to latest Insight Management 7.6 LR2 Support Matrix Guide] - Added support for iLO5 v1.30 - Added support for OA 4.85 and 4.86 - Added support for NCDE 12.30 - Added support for HPE Intelligent Provisioning 3.20 - Added support for 3PAR 3.2.2 EMU4 OS [For Details, refer to latest Insight Management 7.6 LR2 Support Matrix Guide] - Added support for 3PAR 3.2.2 MU6 OS [For Details, refer to latest Insight Management 7.6 LR2 Support Matrix Guide] - Added support for 3PAR 3.3.1 MU2 OS [For Details, refer to latest Insight Management 7.6 LR2 Support Matrix Guide] - Integrated SUM 8.3.1 - Integrated SPP Gen10 2018.06.0 components - Integrated VCRM 7.6.3 Linux package - Integrated VCRM 7.6.4 Windows package - Integrated SNMP-MIBs for Gen-10 hardware (MIB Kit v11.20) Provides fixes for following issues: - HPSIM7.6 postresql wbem EMSHAProvider details page not correct - gatherlogs.tar file is not creating when performing the offline SPP deployment - hpsim7.6 redhat can not delete events - Software status table of RHEL 7.5 target displays improper data - Open-ssh upgrade and update the config file - IPM Enhanced reports return error in Windows SIM 7.6 Jun 2018 HF Important Notes: 1. Users based on Operator-template will Single Sign-On(SSO) with root/administrator access in managed nodes SIM users based on the default administrator or operator-template will Single-Sign-On(SSO) with administrator access to managed systems, whereas users based on the user-template will Single-sign-on(SSO) with user access to managed systems.User created with the operator template are automatically given authorizations to run any CMS tool created with the Run as option set to root/Administrator. Known Issues: 1. Deployment of AMS, WBEM, IM Agents, and SMH on Windows server 1709/1803 fails through Configure-> Configure or Repair Agents in HPE SIM. Microsoft Windows Server 1709/1803 node gets discovered as “Microsoft Windows Server Datacenter/Standard” when discovered with AMS, WBEM or SNMP service (without IM agents on node). Hence,CRA installs the Windows 2000/2003 32bit components and fails. Only OpenSSH component can be installed successfully on the target in this scenario. Suggested action: Install AMS, WBEM, IM Agents and SMH through Deploy->Deploy Drivers,Firmware and Agents->Install Software/Firmware in HPE SIM. CRA deployment of Agents will work on the windows server 1709/1803 node if IM Agents are already installed on it and is discovered with SNMP in HPE SIM,since the node gets discovered as "Windows Server 2016, x64 Datacenter/Standard edition" in this case. HPE SIM enhancements and defect fixes in Feb2018 hotfix update kit: New hardware and software support: - Added support for latest Gen10 Hardware [For Details, refer to latest Insight Management 7.6 LR2 Support Matrix Guide] - Added support for new OS [Managed node], Software, Browser and DataBase [Refer to SIM7.6 Limited Release2 Release Notes] - Added support for iLO5 v1.20 - Added support for Virtual Connect v4.62 - Added support for OA 4.80 - Added support for NCDE 12.20 - Integrated SUM 8.2.0 - Integrated SPP Gen10 2018.03.0 components - Integrated SMH 7.6.3 for Windows and Linux packages - Integrated VCRM 7.6.3 Windows package - Integrated SNMP-MIBs Gen-10 hardware (MIB Kit v11.10) - Integrated Adobe Flash Player v28.0.0.137 for Win and Linux Provides fixes for following issues: - Apache Commons FileUpload module of SIM is vulnerable - CVE-2016-10010 openssh - Empty WBEM Health inclusion status table - SIM needs to stop supporting authorized_keys2 in SSH communication - HPSIM read health status from both 232.11.2.10.7.0 and 232.11.2.10.1.0 oids - Deployments on Linux target from Windows CMS is failing - Vulnerabilities reported against Adobe Flash Player 25.0.0.171 HPE SIM enhancements and defect fixes in Nov2017 hotfix update kit: New hardware, software and features support: - Added support for latest Gen10 Hardware [For Details, refer to latest Insight Management 7.6 LR1 Support Matrix Guide] - Added support for iLO5 v1.15 - Added support for Virtual Connect v4.61 - Added support for NCDE 12.10 - Added support for IRS 7.8 - Added support for 3PAR 3.3.1 MU1 OS - Added support for RHEL 7.4 and SLES 12.3 as managed node - Added support for generating Power Utilization Reports for Gen10 servers in SIM (CMS configured with oracle DB) - Integrated SPP Gen10 2017.10.0 components - Integrated SMH 7.6.2 Windows packages - Integrated SNMP-MIBs for Gen10 hardware (MIB Kit v11.05) - Integrated VCRM 7.6.2 Linux package Provides fixes for following issues: - HPSIM is vulnerable to Privilege Escalation vulnerability - Callback function parameters of multiple SIMJSP pages vulnerable to XSS - Hardware status polling - missing OA snmp health status - AEH trap forwarder takes last entry in list as destination - apostrophe(') string is not shown correctly in NOTICERAWDATA variable - mxinitconfig -l SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder - Legacy Reporting Does not Report iLO4 Firmware Version - File mode and ownership of /etc/inittab were changed by /opt/mx/lbin/hpsim - ILO-Server Associations breaking after re-identifying server for Gen10 models - Issue with ILO5 health status - Task results for wholeSPP on Rhel7.3 displays failure with no details - Improper display of ILO Firmware details in Software status of Gen10 servers HPE SIM enhancements and defect fixes in Jun2017 hotfix update kit: New hardware, software and features support: - Added support for Gen10 Hardware [For details, refer to SIM7.6 Limited Release1 Release Notes] - Added support for new OS [Managed node and CMS], Software, Browser and DataBase [Refer to SIM7.6 Limited Release1 Release Notes] - Added support for HPE Integrity i6 servers with Intel Itanium Processor 9700 series - Added support for iLO5 v1.10 - Added Support for StoreVirtual 3000 File Controller - Added support for generating Power Utilization Reports for Gen10 servers in SIM (CMS configured with MS SQL DB) - Integrated SPP Gen10 2017.07.0 components - Integrated SUM 8.0.0 - Integrated VCRM 7.6.LR1 Windows and Linux packages - Integrated SMH 7.6.1 Windows and Linux packages - Integrated Java CIMClient 2.25 in SIM - Integrated Gen10 hardware related MIBs (MIB Kit v11.00) - Integrated Adobe Flash Player v25.0.0.171 for Win and Linux Provides fixes for following issues: - [KBL][SvrMgmt] - Fail to subscribe ESXi 6.5 with HPSIM - Warning message for Edge Browser incompatibility - SSO fails for ilo4 link provided in server systemPage(Management Processor sect) - hpsim:cpqnic.cfg : Error reading cfg trap-type Unexpected word in macro - Force Installation of VC FW fails while updating VC to SPP baseline - Mismatch in value for "Description" property in events logged in SIM server - Incorrect HPSIM directory in message during Import [DMT Use case] - SNMPv3 credentials is blank in"System credentials -> View all credentials" - Links in "Tools & Links" page hangs for IE11 browser - Quick search list is not displaying - Unable to edit Automatic Event handling task - HPE SIM registration page is not displaying - Shows wrong value for bay no. in system page of a Synergy WS server - For linux CMS, command section in task result page is displaying as "A" - Rebranding of Hotfix Installation output messages - Rebranding changes to PDF format of Enhanced Reports - SIM Functionalities opening in new TAB display not authorized - HP SIM(license manager) is vulnerable to click jacking - DiscoverArrays API returning NULL values for Storage arrays discovered in HPSIM - HPSIM reports negative sign for 0% overcommit (MSA) - Vulnerabilities reported against Adobe Flash Player [Updated Adobe Flash player] - Fails to subscribe ESXi 6.5 with HPSIM - Help about page showing as unknown OS for win 2016 as a CMS - File mode and ownership of /etc/inittab were changed by /opt/mx/lbin/hpsim - Disk Threshold and Replicate Agent settings fail with 2k/4k certificate - Link present in federated cms configuration page not able to browse - Certificates (1k/2k/4k) cannot be pushed to iLO5 through CRA - Openssh Installation fails through CRA and Install Openssh - HPSIM does not open SMH for server, it goes to iLO login page instead. - Renewal of SSH license key in SIM 7.6 LR1 (June 2017 Hot fix update) - Firmware Update on ILO5 node is not working with SIM 7.6 LR1 (June 2017 Hot fix update) - SIM task results Page displays HPSUM instead of SUM. - CRA task is failing on 32 bit target - Install WBEM providers not getting Installed through CRA - HPSIM is vulnerable URL Redirection Attack - cpqiscsi.mib doesn't get register automatically while upgrading to SIM 7.6 LR1 (June 2017 Hot fix update) ---------------------------------------------------------------------------- 1.HOW TO USE: Note1: HPE SIM Aug2021 Hotfix and later will not use SysMgmtDB, HPE SIM require user to install PostgreSQL Note2: HPE SIM Aug2021 Hotfix install will migrate the data from hpsmdb to PostgreSQL automatically as part of upgrade process Prerequisite - If HPE SIM is used with hpsmdb, then Follow instructions from section "2. HOW TO INSTALL POSTGRESQL ON LINUX" to install PostgreSQL 1.1 Download 'SIM76_hotfix_2023_Apr_linux.tar.gz' to its own directory on the system with HP Systems Insight Manager installed. 1.2 Ensure that you are logged in as the "root" user to the system. 1.3 Change directories to the directory containing 'SIM76_hotfix_2023_Apr_linux.tar.gz'. 1.4 Expand the TAR file using the following command: tar -zxvf SIM76_hotfix_2023_Apr_linux.tar.gz 1.5 Change directories to 'SIM76': cd SIM76 1.6 Change the permissions of the installation script to allow the root user to run it. This can be done using the following command: chmod u+x install 1.7 Run the script as follows: ./install 1.8 After a successful installation, you may delete the files unpacked in step 4 if you wish. The entire update should take less than 10 minutes. 1.9 After successful installations, check PostgreSQL 7.x ,8.x ,9.x ,10.x etc is used by SIM using below cli command. # mxgetdbinfo ---------------------------------------------------------------------------- 2. HOW TO INSTALL POSTGRESQL ON LINUX 2.1 Get and install PostgreSQL Packages from respective Operating System Media RHEL 6.x (64-bit): # yum install postgresql-8.4.20-8.el6_9.x86_64 postgresql-libs-8.4.20-8.el6_9.x86_64 postgresql-server-8.4.20-8.el6_9.x86_64 RHEL 6.x (32-bit): # yum install postgresql-8.4.20-8.el6_9.i686 postgresql-libs-8.4.20-8.el6_9.i686 postgresql-server-8.4.20-8.el6_9.i686 RHEL 7.x: # yum install postgresql-9.2.24-4.el7_8.x86_64 postgresql-libs-9.2.24-4.el7_8.x86_64 postgresql-server-9.2.24-4.el7_8.x86_64 SLES 11.x(64 bit): # rpm -ivh postgresql94-9.4.4-0.6.2.x86_64.rpm postgresql94-contrib-9.4.4-0.6.2.x86_64.rpm postgresql94-server-9.4.4-0.6.2.x86_64.rpm postgresql94-docs-9.4.4-0.6.2.x86_64.rpm postgresql-init-9.4-0.2.1.noarch.rpm libpq5-9.4.4-0.6.2.x86_64.rpm SLES 11.x(32 bit): # rpm -ivh postgresql94-9.4.4-0.6.2.i586.rpm postgresql94-contrib-9.4.4-0.6.2.i586.rpm postgresql94-server-9.4.4-0.6.2.i586.rpm postgresql94-docs-9.4.4-0.6.2.i586.rpm postgresql-init-9.4-0.2.1.noarch.rpm libpq5-9.4.4-0.6.2.i586.rpm SLES 12.x : # rpm -ivh postgresql10-contrib-10.10-1.15.1.x86_64.rpm postgresql10-10.10-1.15.1.x86_64.rpm postgresql10-docs-10.10-1.15.1.noarch.rpm postgresql10-server-10.10-1.15.1.x86_64.rpm postgresql-init-10-17.20.1.noarch.rpm libpq5-10.10-1.15.1.x86_64.rpm 2.2 Initialize the postgresql server by running the below command RHEL 6.x # su - postgres $ /usr/bin/initdb -E UTF-8 -D /var/lib/pgsql/data RHEL 7.x #/usr/bin/postgresql-setup initdb SLES 11.x # su - postgres $ /usr/lib/postgresql94/bin/initdb -E UTF-8 -D /var/lib/pgsql/data SLES 12.x # su - postgres $ /usr/lib/postgresql10/bin/initdb -E UTF-8 -D /var/lib/pgsql/data 2.3 Start the PostgreSQL Server # service postgresql start 2.4 Check PostgreSQL Service status # service postgresql status 2.5 Check postgres is Listening on 5432 port # netstat -nlp | grep 5432 2.6 Check and confirm PostgreSQL login works by run below command # su - postgres $ /usr/bin/psql 2.7 enable PostgeSQL service to start after OS reboot # systemctl enable postgresql 2.8 Common Issues and Workarounds: 2.8.1 Service start or psql command may fail due to libpq.so.5 conflict. 2.8.1.1 Issue: service: postgresql.service may fail to start psql: symbol lookup error: psql: undefined symbol: PQconnectionNeedsPassword 2.8.1.2 Workaround: # mv /opt/hpsmdb/lib/libpq.so.5 /opt/hpsmdb/lib/libpq.so.5_DoNotUse 2.8.2 Initialize the database data directory 2.8.2.1 Following error may happen if data directory already exists with unexpected permission. creating directory /usr/local/pgsql/data ... initdb: error: could not create directory "/usr/local/pgsql/data": Permission denied 2.8.2.2 In root prompt, set "postgres" as owner and set 700 permission to data directory as shown in below commands # cd /var/lib/pgsql # chown postgres data # chmod 700 data ---------------------------------------------------------------------------- 3. Uninstalling hpsmdb Note1: HPE SIM Aug2021 hotfix install will migrate the data from hpsmdb to PostgreSQL automatically as part of upgrade process Note2: Verify HPE SIM is loaded with all the data from PostgreSQL before uninstalling hpsmdb Note3: hpsmdb data will be lost after uninstall 3.1 Stop hpsmdb For Red Hat: #/etc/rc.d/init.d/hpsmdb stop For SUSE: #/etc/init.d/hpsmdb stop 3.2 Remove the hpsmdb #rpm -qa | grep hpsmdb | xargs rpm -e --nodeps 3.3 Run the following command to remove hpsmdb directories #rm -rf /var/opt/hpsmdb /opt/hpsmdb --------------------------------------------------------------------------- (C) Copyright 2023 Hewlett Packard Enterprise Development LP Product names mentioned herein may be trademarks and/or registered trademarks of their respective companies -----------------------------------------------------------------------------------------